
## DELETE iowa_liquor_sales

PUT /iowa_liquor_sales
{
  "mappings": {
     "properties": {
        "Invoice/Item Number" : {
            "type" : "keyword"
        },
        "Date" : {
            "type" : "date",
            "format": "yyyy-MM-dd HH:mm:ss||yyyy-MM-dd||epoch_millis || MM/dd/yyyy"
        },
        "Store Number" : {
            "type" : "integer"
        },
        "Store Name" : {
            "type" : "keyword"
        },
        "Address" : {
            "type" : "keyword"
        },
        "City" : {
            "type" : "keyword"
        },
        "Zip Code" : {
            "type" : "keyword"
        },
        "Store Location" : {
            "type" : "keyword"
        },
        "County Number" : {
            "type" : "integer"
        },
        "County" : {
            "type" : "keyword"
        },
        "Category" : {
            "type" : "integer"
        },
        "Category Name" : {
            "type" : "keyword"
        },
        "Vendor Number" : {
            "type" : "integer"
        },
        "Vendor Name" : {
            "type" : "keyword"
        },
        "Item Number" : {
            "type" : "keyword"
        },
        "Item Description" : {
            "type" : "keyword"
        },
        "Pack" : {
            "type" : "integer"
        },
        "Bottle Volume (ml)" : {
            "type" : "integer"
        },
        "State Bottle Cost" : {
            "type" : "double"
        },
        "State Bottle Retail" : {
            "type" : "double"
        },
        "Bottles Sold" : {
            "type" : "integer"
        },
        "Sale (Dollars)" : {
            "type" : "double"
        },
        "Volume Sold (Liters)" : {
            "type" : "double"
        },
        "Volume Sold (Gallons)" : {
            "type" : "double"
        }
     }
  },
  "settings": {
    "index" : {
        "number_of_shards" : "3",
        "number_of_replicas" : "1"
     }
  }
}